package Objects;

public class Biologist implements CRUDClass {

  private String pass_number, address, name, join_year, country;
  private int contributions;

  public Biologist(String pass_number, String address, String name, String join_year, String country, int contributions) {
    this.pass_number = pass_number;
    this.address = address;
    this.name = name;
    this.join_year = join_year;
    this.country = country;
    this.contributions = contributions;
  }

  public String getAddress() {
    return address;
  }

  public void setAddress(String address) {
    this.address = address;
  }

  public int getContributions() {
    return contributions;
  }

  public void setContributions(int contributions) {
    this.contributions = contributions;
  }

  public String getCountry() {
    return country;
  }

  public void setCountry(String country) {
    this.country = country;
  }

  public String getJoin_year() {
    return join_year;
  }

  public void setJoin_year(String join_year) {
    this.join_year = join_year;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public String getPass_number() {
    return pass_number;
  }

  public void setPass_number(String pass_number) {
    this.pass_number = pass_number;
  }

  @Override
  public String toInsert() {
    return "INSERT INTO Biologist VALUES ('" + this.pass_number + "', '" + this.address + "', '" + this.name + "', '"
            + this.join_year + "', '" + this.country + "', " + this.contributions + ");";
  }

  @Override
  public String toUpdate() {
    return "UPDATE Biologist SET Actual_Addr = '" + this.address + "', Name = '" + this.name + "', Joined_Year = '"
            + this.join_year + "', Country = '" + this.country + "' WHERE Passport_Number = " + this.pass_number;
  }

  @Override
  public String toDelete() {
    return "DELETE FROM Biologist WHERE Passport_Number = '" + this.pass_number + "'";
  }
}
